CREATE TABLE [SSB].[finaltbl]
(
[StateStreetIdentifier] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CalendarDate] [date] NULL,
[SecurityDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CUSIP] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LotNumber] [decimal] (38, 10) NULL,
[TradeDate] [date] NULL,
[ActualSettlementDate] [date] NULL,
[AssetClass] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BaseMarketValue] [decimal] (38, 10) NULL,
[BaseOriginalCost] [decimal] (38, 10) NULL,
[SharesParValue] [decimal] (38, 10) NULL,
[BaseUnrealizedGainLoss] [decimal] (38, 10) NULL,
[AmortizedCostBase] [decimal] (38, 10) NULL,
[AmortizedCostLocal] [decimal] (38, 10) NULL,
[ClientFund] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountNumber] [decimal] (38, 10) NULL,
[VariableRate] [decimal] (38, 10) NULL,
[TradeID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MoodysQualityRating] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MaturityDate] [date] NULL,
[InterestRate] [decimal] (38, 10) NULL,
[AlternateLotNumber] [decimal] (38, 10) NULL,
[IssuedatOID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DummyCusipIndicator] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ISINNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReportDate] [date] NULL,
[PostDate] [decimal] (38, 10) NULL,
[CashDate] [date] NULL,
[AccruedAmountBase] [decimal] (38, 10) NULL,
[AccrualTypeCode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LotStatus] [decimal] (38, 10) NULL,
[PurchaseYield] [decimal] (38, 10) NULL,
[Ticker] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VariableRateFrequency] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CurrentIncomeDate] [date] NULL,
[AccrualBasisDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccrualDate] [decimal] (38, 10) NULL,
[AdjustmentIndicator] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ClosingPrice] [decimal] (38, 10) NULL,
[CurrentCallPrice] [decimal] (38, 10) NULL,
[IMID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IMAccountID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocalTotalAccrualToday] [decimal] (38, 10) NULL,
[VariableRateResetDate] [decimal] (38, 10) NULL,
[BaseOriginalUnitCost] [decimal] (38, 10) NULL,
[BaseUnitCost] [decimal] (38, 10) NULL,
[DailyAmortizationFactorBase] [decimal] (38, 10) NULL,
[AmortizationDaysCount] [decimal] (38, 10) NULL
) ON [PRIMARY]
GO
